Editing Object Type Definition

Edit the object type definition under the Definition tab.

The Code Outline window displays information about the object type including declaration, etc. To show the Code Outline window, simply choose Edit -> Code Outline.

Note: Available only in Full Version.

Refresh the code outline.
Turn mouse over highlight on or off.
Show the code outline in a detail way.
Sort by type and name.
Expand the selected item.
Collapse the selected item.

The SQL statements for creating object types are CREATE TYPE. In practice, it is best to use a CREATE OR REPLACE statement. The general form of these statements follows.

      CREATE OR REPLACE 
      TYPE /*TYPE NAME*/ AS OBJECT (
        /* TODO enter type specification (methods, attributes etc) here */
      )
	

Hint: To customize the view of the editor and find out more features for sql editing, see Editor View and More Features.